exceldatareader example c#

104

exceldatareader example c# -

1
private void btnBrowse_Click(object sender, EventArgs e)
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;this.openFileDialog1.Filter = "Excel Files(.xlsx)|*.xlsx";
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;this.openFileDialog1.Title = "Select an excel file";
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if (this.openFileDialog1.ShowDialog() == DialogResult.OK)
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;this.txtPath.Text = openFileDialog1.FileName;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FileStream stream = File.Open(openFileDialog1.FileName, FileMode.Open, FileAccess.Read);
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DataSet result = excelReader.AsDataSet();
&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var people = new List&amp;amp;amp;lt;Person&amp;amp;amp;gt;();
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;while (excelReader.Read())
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;people.Add(new Person
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FirstName = excelReader.GetString(0),
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;LastName = excelReader.GetString(1)
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;});
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;this.resultGrid.DataSource = people;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}

Comments

Submit

0 Comments

More Questions

url()- full() laravel	how to print in c#	c# how to sort a list
print in c#	get mouse position unity	c# initialize array
string to int c#	Retrieve url path	Generate Random String
string to date vb	modal bootstrap style	abril modal boostrap
c# serialize json	boostrap 4 modal	small modal popup bootstrap
model in bootsrap 4	bootstrap modal popup	c# random string
c sharp split string	string to json c#	laravel get current url
how get url in laravel	how to generate random letters in C#	string to date
laravel route redirect	check if two date ranges overlap c#	Console.WriteLine($Hello Ana.ToUpper($)!);
phone number regex in c#	list min and Max value in c#	check shell command success
attribute c# get method name reflection	c# how to get screen resolution in class	how to make dissapear an object in unity
wpf label text in center	hahhaa i hack u	difference between all logging framework .NET Core
new color unity	c# count files in directory and subdirectories	Hello World Dotnet
import tachyons in react	How can I cast string to enum	.net core add header to soap request
open html file in browser using c++	git find commits by message	c# generate random date
how to get angular on visual studio mac	dotnet core encryption and decryption	asp.net list all files in folder

exceldatareader example c#

exceldatareader example c# -

Comments

0 Comments

More Questions

C

CSS

Objective-C

PHP

Java

C++

Javascript

Html

Python

SQL

Swift

Ruby

Go

R

TypeScript

Kotlin

Assembly

VBA

Scala

Rust

Elixir

Dart

Haskell

Perl

Fortran

Matlab

Scheme

Julia

Lua

Delphi

Pascal

Solidity

BASIC

ActionScript

Csharp